Viewing Form Reports

If a form is set to store data in the database, you can run a report that displays the submitted data. To view a form report, follow these steps.

1. Navigate to the folder for which you want to view the report. The View Contents of Folder screen appears.

2. Click the form you want to view. (If you do not see your form in the folder, make sure the Content Type drop-down box is set to All Types or Forms.)

3. Click View Reports ().

4. The View Forms Report screen appears.

5. Enter report criteria using the following table as a reference.

Field	Description
Start Date	If desired, specify a start date. The report displays only forms that were submitted on or after the start date.
End Date	If desired, specify an end date. The report displays only forms that were submitted on or before the end date.
Report Display	Specify the format to display the report.
Select Legacy Report	Specify the version of the form or poll for which to get a report. Using this option allows you to see the results from previous polls and forms.

6. Click Get Result to display the report.

Display Formats

The submitted form data can be viewed in any of these formats.

Table with Totals

Summary of Selected Choices

Table of Values

List of Submitted Values

Submitted Data as XML

Table with Totals

The table of values shows the following information for each completed form.

a checkbox that lets you delete the response

an internal identification number of the response

the name of the user who submitted the form, if he signed in to Ektron CMS400.NET beforehand. If the user did not sign in, anonymous appears.

date response was submitted

The name of each field on the survey

- under each field name is the submitted response for the each user

the bottom line sums the numerical and percentage totals for each response

Sample of Table with Totals Format

Summary of Selected Choices

This format totals, for choice and select type fields, the number of times each choice was selected. Only choices that were selected at least once appear.

Sample Summary of Selected Choices Format

Table of Values

The table of values shows the following information for each completed form.

a checkbox that lets you delete the response

an internal identification number of the response

the name of the user who submitted the form, if he signed in to Ektron CMS400.NET beforehand. If the user did not sign in, anonymous appears.

date response was submitted

descriptive name of each form field appears in the column header

- the value entered for each field appears below the header

Sample of Table of Values Format

List of Submitted Values

The List of Submitted Values format provides the same information as the Table of Values, but is formatted vertically rather than horizontally. See Also: Table of Values

Sample List of Submitted Values Format

Submitted Data as XML

Displays the results of the form in an XML format. The following information is included:

<Title> - title of the form block

Warning! With polls you can create a new poll question to replace an existing poll question. By default the poll still has the same Title, ID, and other properties. You can change the title of a new poll question when you are editing the poll.

<Description> - description of the form

<SubmittedData> - information that was submitted

Sample of Submitted Data as XML

Learn About Exporting Form Reports

Exporting a Form’s Raw Data

After you run a report, you can export its data to a Microsoft Excel spreadsheet file (.xls) for further analysis. If a form uses an XML structure, each XML tag becomes a column header in the spreadsheet.

To export form data, follow these steps.

1. Access the View Form Reports screen for the report you want to export, as described in Viewing Form Reports.

2. Click .

3. A File Download dialog box is displayed. Choose the option that best suits your needs.

4. After the data is exported, you can analyze and modify the .xls file.